SELECT ident, naziv,IF( slika_1 IS NULL ,'/gfx/_box-images/ni_slike.jpg',slika_1) as slika_1,cena_pred_akcijo,cena FROM _produkti_aures
WHERE kategorija = 'Čelade Airoh'
ORDER BY cena LIMIT 9,9
Airoh Trr S
149,99 €
Airoh Helios UP FLUO
169,99 €
Airoh Helios UP PINK GLOSS
169,99 €
Airoh Helios UP bela
169,99 €
Airoh Valor CRAFT
169,99 €
Airoh Valor Akuna siva
169,99 €
Airoh Valor Akuna fluo
169,99 €
Airoh Valor RIBS MATT
169,99 €
AIROH VALOR WINGS ORANGE MATT
169,99 €